CKT_SCHOOL

%RULES%

alter table class
drop constraint FK_CLASS_SC_CL_REL_SCHOOL
go

if exists (select 1
from sysobjects
where id = object_id('school')
and type = 'U')
drop table school
go

/*==============================================================*/
/* Table: school */
/*==============================================================*/
create table school (
schno int not null,
schname varchar(30) null,
constraint PK_SCHOOL primary key (schno)
)
go

CKC_SCHNO_SCHOOL

%MINMAX% and %LISTVAL% and %RULES%

CKC_SCHNAME_SCHOOL

%MINMAX% and %LISTVAL% and %RULES%

alter table school
drop constraint PK_SCHOOL
go

CKT_STUDENT

%RULES%

alter table student
drop constraint FK_STUDENT_CL_ST_REL_CLASS
go

alter table 考试
drop constraint FK_考试_考试2_STUDENT
go

if exists (select 1
from sysindexes
where id = object_id('student')
and name = 'student_PK'
and indid > 0
and indid < 255)
drop index student.student_PK
go

if exists (select 1
from sysindexes
where id = object_id('student')
and name = 'CL_ST_relasion_FK'
and indid > 0
and indid < 255)
drop index student.CL_ST_relasion_FK
go

if exists (select 1
from sysobjects
where id = object_id('student')
and type = 'U')
drop table student
go

/*==============================================================*/
/* Table: student */
/*==============================================================*/
create table student (
sno int not null,
bno int null,
snumber varchar(40) null,
sname varchar(30) null,
ssex smallint null,
sbirth datetime null,
sminzu smallint null,
sparty varchar(20) null,
spcode varchar(40) null,
shome varchar(40) null,
sparent varchar(16) null,
sparentwork varchar(40) null,
scode varchar(14) null,
shometele varchar(20) null,
constraint PK_STUDENT primary key (sno)
)
go

/*==============================================================*/
/* Index: student_PK */
/*==============================================================*/
create unique index student_PK on student (
sno ASC
)
go

/*==============================================================*/
/* Index: CL_ST_relasion_FK */
/*==============================================================*/
create index CL_ST_relasion_FK on student (
bno ASC
)
go

alter table student
add constraint FK_STUDENT_CL_ST_REL_CLASS foreign key (bno)
references class (bno)
go

CKC_SNO_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_BNO_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SNUMBER_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SNAME_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SSEX_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SBIRTH_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SMINZU_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SPARTY_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SPCODE_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SHOME_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SPARENT_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SPARENTWORK_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SCODE_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

CKC_SHOMETELE_STUDENT

%MINMAX% and %LISTVAL% and %RULES%

alter table student
drop constraint PK_STUDENT
go

if exists (select 1
from sysindexes
where id = object_id('student')
and name = 'student_PK'
and indid > 0
and indid < 255)
drop index student.student_PK
go

/*==============================================================*/
/* Index: student_PK */
/*==============================================================*/
create unique index student_PK on student (
sno ASC
)
go

if exists (select 1
from sysindexes
where id = object_id('student')
and name = 'CL_ST_relasion_FK'
and indid > 0
and indid < 255)
drop index student.CL_ST_relasion_FK
go

/*==============================================================*/
/* Index: CL_ST_relasion_FK */
/*==============================================================*/
create index CL_ST_relasion_FK on student (
bno ASC
)
go

CKT_MANAGER

%RULES%

if exists (select 1
from sysindexes
where id = object_id('manager')
and name = 'manager_PK'
and indid > 0
and indid < 255)
drop index manager.manager_PK
go

if exists (select 1
from sysobjects
where id = object_id('manager')
and type = 'U')
drop table manager
go

/*==============================================================*/
/* Table: manager */
/*==============================================================*/
create table manager (
mno int not null,
mname varchar(20) null,
mpass varchar(20) null,
mdegree smallint null,
constraint PK_MANAGER primary key (mno)
)
go

/*==============================================================*/
/* Index: manager_PK */
/*==============================================================*/
create unique index manager_PK on manager (
mno ASC
)
go

CKC_MNO_MANAGER

%MINMAX% and %LISTVAL% and %RULES%

CKC_MNAME_MANAGER

%MINMAX% and %LISTVAL% and %RULES%

CKC_MPASS_MANAGER

%MINMAX% and %LISTVAL% and %RULES%

CKC_MDEGREE_MANAGER

%MINMAX% and %LISTVAL% and %RULES%

alter table manager
drop constraint PK_MANAGER
go

if exists (select 1
from sysindexes
where id = object_id('manager')
and name = 'manager_PK'
and indid > 0
and indid < 255)
drop index manager.manager_PK
go

/*==============================================================*/
/* Index: manager_PK */
/*==============================================================*/
create unique index manager_PK on manager (
mno ASC
)
go

CKT_教师派课单

%RULES%

alter table 教师派课单
drop constraint FK_教师派课单_教师派课单_TEACHER
go

alter table 教师派课单
drop constraint FK_教师派课单_教师派课单2_COURSE
go

alter table 教师派课单
drop constraint FK_教师派课单_教师派课单3_CLASS
go

if exists (select 1
from sysindexes
where id = object_id('教师派课单')
and name = '教师派课单_PK'
and indid > 0
and indid < 255)
drop index 教师派课单.教师派课单_PK
go

if exists (select 1
from sysindexes
where id = object_id('教师派课单')
and name = '教师派课单_FK'
and indid > 0
and indid < 255)
drop index 教师派课单.教师派课单_FK
go

if exists (select 1
from sysindexes
where id = object_id('教师派课单')
and name = '教师派课单2_FK'
and indid > 0
and indid < 255)
drop index 教师派课单.教师派课单2_FK
go

if exists (select 1
from sysindexes
where id = object_id('教师派课单')
and name = '教师派课单3_FK'
and indid > 0
and indid < 255)
drop index 教师派课单.教师派课单3_FK
go

if exists (select 1
from sysobjects
where id = object_id('教师派课单')
and type = 'U')
drop table 教师派课单
go

/*==============================================================*/
/* Table: 教师派课单 */
/*==============================================================*/
create table 教师派课单 (
tno int not null,
cno int not null,
bno int not null,
tcno int not null,
skxqsk varchar(0) null,
sktime smallint null,
constraint PK_教师派课单 primary key (tcno)
)
go

/*==============================================================*/
/* Index: 教师派课单_PK */
/*==============================================================*/
create unique index 教师派课单_PK on 教师派课单 (
tcno ASC
)
go

/*==============================================================*/
/* Index: 教师派课单_FK */
/*==============================================================*/
create index 教师派课单_FK on 教师派课单 (
tno ASC
)
go

/*==============================================================*/
/* Index: 教师派课单2_FK */
/*==============================================================*/
create index 教师派课单2_FK on 教师派课单 (
cno ASC
)
go

/*==============================================================*/
/* Index: 教师派课单3_FK */
/*==============================================================*/
create index 教师派课单3_FK on 教师派课单 (
bno ASC
)
go

alter table 教师派课单
add constraint FK_教师派课单_教师派课单_TEACHER foreign key (tno)
references teacher (tno)
go

alter table 教师派课单
add constraint FK_教师派课单_教师派课单2_COURSE foreign key (cno)
references course (cno)
go

alter table 教师派课单
add constraint FK_教师派课单_教师派课单3_CLASS foreign key (bno)
references class (bno)
go

CKC_TNO_教师派课单

%MINMAX% and %LISTVAL% and %RULES%

CKC_CNO_教师派课单

%MINMAX% and %LISTVAL% and %RULES%

CKC_BNO_教师派课单

%MINMAX% and %LISTVAL% and %RULES%

CKC_TCNO_教师派课单

%MINMAX% and %LISTVAL% and %RULES%

CKC_SKXQSK_教师派课单

%MINMAX% and %LISTVAL% and %RULES%

CKC_SKTIME_教师派课单

%MINMAX% and %LISTVAL% and %RULES%

alter table 教师派课单
drop constraint PK_教师派课单
go

if exists (select 1
from sysindexes
where id = object_id('教师派课单')
and name = '教师派课单_PK'
and indid > 0
and indid < 255)
drop index 教师派课单.教师派课单_PK
go

/*==============================================================*/
/* Index: 教师派课单_PK */
/*==============================================================*/
create unique index 教师派课单_PK on 教师派课单 (
tcno ASC
)
go

if exists (select 1
from sysindexes
where id = object_id('教师派课单')
and name = '教师派课单_FK'
and indid > 0
and indid < 255)
drop index 教师派课单.教师派课单_FK
go

/*==============================================================*/
/* Index: 教师派课单_FK */
/*==============================================================*/
create index 教师派课单_FK on 教师派课单 (
tno ASC
)
go

if exists (select 1
from sysindexes
where id = object_id('教师派课单')
and name = '教师派课单2_FK'
and indid > 0
and indid < 255)
drop index 教师派课单.教师派课单2_FK
go

/*==============================================================*/
/* Index: 教师派课单2_FK */
/*==============================================================*/
create index 教师派课单2_FK on 教师派课单 (
cno ASC
)
go

if exists (select 1
from sysindexes
where id = object_id('教师派课单')
and name = '教师派课单3_FK'
and indid > 0
and indid < 255)
drop index 教师派课单.教师派课单3_FK
go

/*==============================================================*/
/* Index: 教师派课单3_FK */
/*==============================================================*/
create index 教师派课单3_FK on 教师派课单 (
bno ASC
)
go

CKT_TEACHER

%RULES%

alter table teacher
drop constraint FK_TEACHER_TC_DP_REL_DEPART
go

alter table Depart
drop constraint FK_DEPART_TC_DP_REL_TEACHER
go

alter table course
drop constraint FK_COURSE_教师授课_TEACHER
go

alter table 教师派课单
drop constraint FK_教师派课单_教师派课单_TEACHER
go

if exists (select 1
from sysindexes
where id = object_id('teacher')
and name = 'teacher_PK'
and indid > 0
and indid < 255)
drop index teacher.teacher_PK
go

if exists (select 1
from sysindexes
where id = object_id('teacher')
and name = 'Tc_DP_relasion2_FK'
and indid > 0
and indid < 255)
drop index teacher.Tc_DP_relasion2_FK
go

if exists (select 1
from sysobjects
where id = object_id('teacher')
and type = 'U')
drop table teacher
go

/*==============================================================*/
/* Table: teacher */
/*==============================================================*/
create table teacher (
tno int not null,
dno smallint null,
tname varchar(30) null,
tpass varchar(20) null,
tzc varchar(20) null,
txb smallint null,
tdegree varchar(16) null,
tprofess varchar(30) null,
ttele varchar(30) null,
constraint PK_TEACHER primary key (tno)
)
go

/*==============================================================*/
/* Index: teacher_PK */
/*==============================================================*/
create unique index teacher_PK on teacher (
tno ASC
)
go

/*==============================================================*/
/* Index: Tc_DP_relasion2_FK */
/*==============================================================*/
create index Tc_DP_relasion2_FK on teacher (
dno ASC
)
go

alter table teacher
add constraint FK_TEACHER_TC_DP_REL_DEPART foreign key (dno)
references Depart (dno)
go

CKC_TNO_TEACHER

%MINMAX% and %LISTVAL% and %RULES%

CKC_DNO_TEACHER

%MINMAX% and %LISTVAL% and %RULES%